Create KPI's Card 14

How to create KPI's

YOY KPI = [CY Death]/[LY Death]-1

Create Death Per Mth KPI

Death Per Mth = Death per Mth =

AVERAGEX( 
                      VALUES( Fentayl_Drug_Related_Deaths[Date].[Month]),
                      [death #]
                     )

Create Total Death KPI

Total Death = Total Death by Fentayl = CALCULATE(COUNT(Fentayl_Drug_Related_Deaths[MannerofDeath])

,FILTER(Fentayl_Drug_Related_Deaths,Fentayl_Drug_Related_Deaths[MannerofDeath] = "Accident"))

KPIs are a great choice:

To measure progress. Answers the question, "What am I ahead or behind on?"
To measure distance to a goal. Answers the question, "How far ahead or behind am I?"
click below link for more information
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi